/*
 Navicat Premium Data Transfer

 Source Server         : my
 Source Server Type    : MySQL
 Source Server Version : 80024
 Source Host           : 120.77.247.62:3306
 Source Schema         : blog

 Target Server Type    : MySQL
 Target Server Version : 80024
 File Encoding         : 65001

 Date: 18/12/2021 20:02:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章id',
  `user_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
  `type_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型id',
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
  `center` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主体内容',
  `create_time` datetime DEFAULT NULL COMMENT '发布时间',
  `reading_num` int DEFAULT NULL COMMENT '阅读数量',
  `img_src` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES ('178c91f2-70fe-498b-8e49-3feeaa93be9b', '112323', NULL, 'sdasdww', 'fsadfasdas666', '2021-12-15 13:20:22', NULL, NULL);
INSERT INTO `article` VALUES ('5d722e18-b7d0-479f-b5c1-e44bd5feb6e0', '112323', NULL, 'Java入门到精通', '你好，欢迎来到C语言中文网阅读“Java 教程”，你将享受到免费的 Java 学习资料，以及良好的阅读体验。\n\n这套教程适用于没有任何 Java 基础，或者基础薄弱的学员，它通俗易懂，并且非常全面，30 天从入门到精通不是神话。\n\n关于 Java 语言\n\n由于 JVM 的支持，使得 Java 成为一种跨平台的编程语言，一次编写，到处运行；换句话说，一段 Java 代码可以不加修改地在 Windows、Linux、Mac OS、UNIX 等平台运行。JVM 是重点学习内容。\n\n在世界编程语言排行榜中，近年来 Java 一直稳居第一名，比第二名的C语言高出几个百分点。\n \n\n世界编程语言排行榜\n图：2018 年 09 月份世界编程语言排行榜\n\n\nJava 最初是由 SUN 公司推出的，后来 SUN 公司被 Oracle 公司收购，Java 的版权也就归属了 Oracle。Java 的官方网址是 https://www.java.com/，你可以在此下载最新版本，关注最新资讯。\n\nJava 是一门半编译型的语言，Java 源码先被编译为字节码文件（中间文件），然后再由虚拟机（JVM）解释执行，这肯定比直接编译成二进制文件的运行速度要慢一些。\n\n不过 Java 经过了多年的性能调优，再加上即时编译技术（JIT）的加持，性能已经相当出色了，甚至成了传统编译器的竞争对手，某些情况下甚至还超出了传统编译器（整体上还是不及 C/C++ 的）。\n\nJava 的应用\n\nJava 是一门用途广泛的语言，不但可以用来开发网站后台、PC 客户端和 Android APP，还在数据分析、网络爬虫、云计算领域大显身手。\n\n不过，Java 还是与目前最火热的机器学习（人工智能）失之交臂，这个领域是 Python 的天下。\n\nJava 学习建议\n\n从学术的角度讲，Java 是一门面向对象的编程语言，初学者需要花费不少时间来熟悉面向对象的概念、语法和编程思想，有不理解的地方请大家一定要坚持，多花时间编写代码自然会豁然开朗。只有一步一个脚印，踏踏实实学习，才能从零基础到入门，再到精通。\n\n大家在学习的过程中也要多看几套 Java 教程，不要死啃一本书，这样才能才能博采众长，进步更快。', '2021-12-16 21:01:57', NULL, NULL);
INSERT INTO `article` VALUES ('78d3d859-e84e-4e79-953d-9874a259d01d', '112323', NULL, 'dsad', 'dasd', '2021-12-15 13:21:11', NULL, NULL);
INSERT INTO `article` VALUES ('f18fe2aa-2d6d-4fdf-9ebc-0240fa71aae5', '112323', NULL, 'sdasd', 'fsadfasdas666', '2021-12-15 13:20:18', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for article_type
-- ----------------------------
DROP TABLE IF EXISTS `article_type`;
CREATE TABLE `article_type` (
  `id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型id',
  `type_name` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型名称'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of article_type
-- ----------------------------
BEGIN;
INSERT INTO `article_type` VALUES ('8157aee2-6714-40c1-a1e3-a140fb113f32', '技术');
INSERT INTO `article_type` VALUES ('93f5c475-ceca-4a75-8b51-8f71b7687498', '其他');
INSERT INTO `article_type` VALUES ('aa604782-8f24-4506-a81d-89808f7f039a', 'mysql');
INSERT INTO `article_type` VALUES ('badd2f0d-6036-4513-b6b7-d536723570d0', 'Java');
INSERT INTO `article_type` VALUES ('18bb447b-cefd-4b45-a041-d0bde974db79', '测试');
INSERT INTO `article_type` VALUES ('56a3196c-f8c0-4e0d-ac26-8b71ed14f44e', 'PHP');
COMMIT;

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `letter_comments_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '收到评论的用户id',
  `article_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文章id',
  `center` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评论内容',
  `user_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评论者id',
  `create_time` datetime DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of comments
-- ----------------------------
BEGIN;
INSERT INTO `comments` VALUES (1, NULL, '2', NULL, NULL, '2021-12-03 22:56:34');
INSERT INTO `comments` VALUES (2, NULL, '2', NULL, NULL, '2021-12-03 22:56:38');
INSERT INTO `comments` VALUES (3, NULL, '2', NULL, NULL, '2021-12-03 22:59:57');
INSERT INTO `comments` VALUES (4, '112323', '1', '5fdsfsd', '112323', '2021-12-05 11:50:28');
INSERT INTO `comments` VALUES (5, '112323', '1', '999999', '112323', '2021-12-05 17:21:51');
INSERT INTO `comments` VALUES (6, '112323', '1', '太棒了呀', '112323', '2021-12-05 17:23:29');
INSERT INTO `comments` VALUES (7, '112323', '1', '3432423', '112323', '2021-12-05 17:24:47');
INSERT INTO `comments` VALUES (8, '112323', '1', '9999', '112323', '2021-12-05 17:25:34');
INSERT INTO `comments` VALUES (9, '112323', '4', '333', '112323', '2021-12-05 17:26:09');
INSERT INTO `comments` VALUES (10, '112323', '1', '哈哈哈啊哈', '112323', '2021-12-05 17:28:07');
INSERT INTO `comments` VALUES (11, '112323', '1', '999', '112323', '2021-12-05 21:26:33');
INSERT INTO `comments` VALUES (12, '4450d66d-279f-49f3-9fd5-49c95672f86a', '80d84ad6-83ac-480d-bbd8-bcda184465d1', '45648', '112323', '2021-12-07 22:04:49');
INSERT INTO `comments` VALUES (13, '112323', '6', '6666698', '112323', '2021-12-07 22:07:06');
INSERT INTO `comments` VALUES (14, '112323', '1', '2222', '112323', '2021-12-07 22:28:05');
INSERT INTO `comments` VALUES (15, '112323', '1', '323232', '112323', '2021-12-07 22:37:55');
INSERT INTO `comments` VALUES (16, '112323', '096ab802-2c0f-454c-8c82-1d72d244d838', '5555', '112323', '2021-12-07 22:38:46');
INSERT INTO `comments` VALUES (17, '112323', '096ab802-2c0f-454c-8c82-1d72d244d838', '阿哈哈哈哈哈哈哈哈', 'a70065a4-473b-4999-8c08-747613cc47b7', '2021-12-07 22:43:08');
INSERT INTO `comments` VALUES (18, '112323', '5e0a685e-dfee-4574-9c2f-0fcf028bc936', '活动时间可否黄金时代返回键即可收到了回房间可视电话', '112323', '2021-12-08 18:26:43');
INSERT INTO `comments` VALUES (19, '112323', '1', '543534534534', '112323', '2021-12-09 16:07:40');
INSERT INTO `comments` VALUES (20, '112323', '46ebae33-6a7e-47b6-b226-18ac29eaf874', '就没vs六道口V马上到了昆明没收到款铝木收到看了', '112323', '2021-12-09 16:08:54');
INSERT INTO `comments` VALUES (21, 'a25cedf3-86a4-4475-9448-aea23ebe15e7', '8608a62b-2241-4419-8d15-0f8e721022f5', 'V你速度快论谁都没离开mkv类似的', 'a25cedf3-86a4-4475-9448-aea23ebe15e7', '2021-12-09 17:01:09');
INSERT INTO `comments` VALUES (22, '112323', '178c91f2-70fe-498b-8e49-3feeaa93be9b', 'hahahha', 'ea8f98cc-1bd2-439c-91f2-f72a3378bc26', '2021-12-16 20:18:23');
COMMIT;

-- ----------------------------
-- Table structure for direct_msg
-- ----------------------------
DROP TABLE IF EXISTS `direct_msg`;
CREATE TABLE `direct_msg` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `letter_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '发信者id',
  `Keep_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '收信者id',
  `center` varchar(200) COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of direct_msg
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for friends_list
-- ----------------------------
DROP TABLE IF EXISTS `friends_list`;
CREATE TABLE `friends_list` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
  `friends_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '好友id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of friends_list
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for leave_msg
-- ----------------------------
DROP TABLE IF EXISTS `leave_msg`;
CREATE TABLE `leave_msg` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '留言者id',
  `receive_user_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '接收者id',
  `center` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '刘亚吧内容',
  `create_time` datetime DEFAULT NULL COMMENT '留言时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of leave_msg
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for reply_comments
-- ----------------------------
DROP TABLE IF EXISTS `reply_comments`;
CREATE TABLE `reply_comments` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `reply_user_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '收到回复的id',
  `reply_comments_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回复评论的id',
  `comments_center` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回复的评论内容',
  `center` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回复内容',
  `user_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '评论者id',
  `create_time` datetime DEFAULT NULL COMMENT '回复时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of reply_comments
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `center` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of sys_notice
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `nike_name` varchar(40) COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `login_name` varchar(40) COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录账号',
  `password` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录密码',
  `birthday` datetime DEFAULT NULL COMMENT '生日',
  `signature` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '签名',
  `img_src` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像地址',
  `fans_num` int DEFAULT NULL COMMENT '粉丝数',
  `Focus_num` int DEFAULT NULL COMMENT '关注数',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('112323', '阿拉啦阿拉啦', 'admin', '4297f44b13955235245b2497399d7a93', NULL, '哈哈哈嘻嘻嘻啦啦啦哦哦哦', NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES ('4450d66d-279f-49f3-9fd5-49c95672f86a', '快快快', '123456', '4297f44b13955235245b2497399d7a93', NULL, 'gsdgdsgdsg', NULL, NULL, NULL, '2021-12-06 23:04:30');
INSERT INTO `user` VALUES ('64f32788-9c30-48df-adf9-c5c596c772ac', '123', '10001', 'd41d8cd98f00b204e9800998ecf8427e', NULL, '福建省地方还拿手机发你的手机放那就是打开', NULL, NULL, NULL, '2021-12-15 18:41:33');
INSERT INTO `user` VALUES ('a1bc9dd2-b87b-4a71-9f46-589d001084fc', '快快快', '123456', '63ee451939ed580ef3c4b6f0109d1fd0', NULL, '繁华的世界开放后的手机壳', NULL, NULL, NULL, '2021-12-15 19:12:36');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
